Aleno Token Report PoC

This POC is done on ERC20 contracts where we analyse the token holders. This same analysis can be done on any contract type to analyze the users and can be automated

Token general information

Token name :  agEUR
Token symbol :  agEUR
Token ID 52541
Statistics computed 2022-10-21 18:14:00
 Price 0.9844077
total dex volume 1 B agEUR
total dex usd volume 1 B$

agEUR is swapped in 8 pools on 3 different exchanges

address	protocol_id	swap_count	usd_volume
0x8db1b906d47dfc1d84a87fc49bd0522e285b98b9	Uniswap v3	21272	235826735.000000
0x735a26a57a0a0069dfabd41595a970faf5e1ee8b	Uniswap v3	21115	516202305.000000
0x7ed3f364668cd2b9449a8660974a26a092c64849	Uniswap v3	6056	435974000.000000
0x1f4c763bde1d4832b3ea0640e66da00b98831355	SushiSwap	5833	58649600.000000
0x9496d107a4b90c7d18c703e8685167f90ac273b0	Uniswap v3	4538	115947008.000000
0x8ce5796ef6b0c5918025bcf4f9ca908201b030b3	Uniswap v3	3196	111646155.000000
0x3aaa7f4c1f6bce9b01462905776655386b74a29a	Uniswap v2	616	790957.400000
0xf89ce5ed65737da8440411544b0499c9fad323b2	Uniswap v2	580	7014162.250000

Price evolution

Accounts analysis

2577 have been exposed to agEUR through decentralized exchanges on ethereum
1238 accounts have bought agEUR on decentralized exchanges and have a non null balance
585 are currently holding agEUR

At the moment we can analyse 3 types of players:

• All the addresses that interacted with the token through DEXES
• All the addresses that bought some tokens though DEXES without selling them
• All the "True" token holders

Holdings distribution without extreme values

151 holders have more than 100 agEUR

Some dapps offer a tiering systems for they users that enables different perks. The following analysis could be split into the analysis of these different tiers to display major differencies between those groups.

Holders Description

Comparer avec les gens qui swap le token utiliser les balances etherscan Regarder l'activité de swapping labeliser non swapper address labeliser passif holders plutot que simple holder

There were 281 active accounts last month

Labeling definition can be improved. What other labels should we add ?

We could add a graph showing the distribution of the age of the users

Some accounts are not labeled since they don't apear in our database. Should we add them ?

Some addresses might have transferred their tokens to other addresses or other chains so holders are not 100% exact. Tracking those transfers could be added for a slight improvement. Current analysis is quite representative when empirically verifying results

We could also cludter the related accounts that have done some inner transfers

This analysis could be handled on all the addresses that interacted with the tokens and not only the current holders

From here bots are removed from the analysis

Removing 1.35% bot accounts from the analysis

Should We add the distribution only for users ? Or most precisely active users ?

Show recent holders interaction (4 weeks old)

Recent asset swapped

Notable recent tokens swaped by agEUR holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']

address	name	symbol	swap_count	total_dollar_volume
0x1a7e4e63778b4f12a199c062f3efdd288afcbce8	agEUR	agEUR	584	18585993.137293
0x1abaea1f7c830bd89acc67ec4af516284b1bc33c	Euro Coin	EUROC	185	4185397.337500
0x853d955acef822db058eb8505911ed77f175b99e	Frax	FRAX	143	2668980.364335
0x956f47f50a910163d8bf957cf5846d573e7f87ca	Fei USD	FEI	34	488109.145001
0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0	Frax Share	FXS	113	436328.250813
0x03ab458634910aad20ef5f1c8ee96f1d6ac54919	Rai Reflex Index	RAI	20	303966.701620
0x4fabb145d64652a948d72533023f6e7a623c7c53	Binance USD	BUSD	26	292900.925140
0x31429d1856ad1377a8a0079410b297e1a9e214c2	ANGLE	ANGLE	75	198200.026629
0xd9fcd98c322942075a5c3860693e9f4f03aae07b	Euler	EUL	56	187387.374429
0x954b890704693af242613edef1b603825afcd708	Cardstack	CARD	49	152941.413495
0x0f2d719407fdbeff09d87557abb7232601fd9f29	Synapse	SYN	9	138539.716324
0x111111111117dc0aa78b770fa6a738034120c302	1INCH Token	1INCH	7	138006.194880
0xd533a949740bb3306d119cc777fa900ba034cd52	Curve DAO Token	CRV	76	126394.211331
0x68037790a0229e9ce6eaa8a99ea92964106c4703	PAR Stablecoin	PAR	6	126004.314290
0x41f7b8b9b897276b7aae926a9016935280b44e97	USD Coin	USDC	4	113594.320000
0xae78736cd615f374d3085123a210448e74fc6393	Rocket Pool ETH	rETH	12	107629.745815
0xc5bddf9843308380375a611c18b50fb9341f502a	veCRV-DAO yVault	yveCRV-DAO	29	94517.711450
0x5f98805a4e8be255a32880fdec7f6728c6568ba0	LUSD Stablecoin	LUSD	22	84753.425205
0x7659ce147d0e714454073a5dd7003544234b6aa0	XCAD Token	XCAD	27	76471.796280
0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6	Decentralized USD	USDD	3	70113.784937

Do we need to analyze recent swaps more in depth ?

Recent contract interaction by removing ERC20 Tokens

to_address	transaction_count	unique_account_count	label
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45	344	78	Uniswap V3 Router
0x1111111254fb6c44bac0bed2854e76f90643097d	812	63	1inch v4 Router
0xf403c135812408bfbe8713b5a23a04b3d48aae31	111	47	Convex Finance: Booster
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	476	45	Paraswap Augustus v5
0xdd49a93fdcae579ae50b4b9923325e9e335ec82b	64	35	Convex: Claim Zap
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	126	35	SushiSwap Router
0x633120100e108f03ace79d6c78aac9a56db1be0f	45	30	Stake DAO Claim Rewards
0xdef1c0ded9bec7f1a1670819833240f027b25eff	74	26	0x: Exchange Proxy
0x00000000006c3852cbef3e08e8df289169ede581	143	25	Seaport 1.1
0x5de4ef4879f4fe3bbadf2227d2ac5d0e2d76c895	46	20	nan
0x72a19342e8f1838460ebfccef09f6585e32db86e	46	20	Vote Locked Convex Token (vlCVX)
0x03e34b085c52985f6a5d27243f20c84bddc01db4	30	20	nan
0x569f5b842b5006ec17be02b8b94510ba8e79fbca	36	19	Convex Booster
0xba3436fd341f2c8a928452db3c5a3670d1d5cc73	49	19	Curve.fi Factory Plain Pool: agEUR/EUROC
0xa0c68c638235ee32657e8f720a23cec1bfc77c77	43	19	Polygon Matic Bridge
0xa79828df1850e8a3a3064576f380d90aecdd3359	33	19	Curve Finance: 3Pool Deposit Zap
0xba12222222228d8ba445958a75a0704d566bf2c8	86	18	Balancer Vault
0xbb755240596530be0c1de5dfd77ec6398471561d	35	17	Angle Protocol Router
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f	20	16	Arbitrum: Delayed Inbox
0xb9446c4ef5ebe66268da6700d26f96273de3d571	47	16	Curve.fi Factory Plain Pool: 3EURpool
0xe7a3b38c39f97e977723bd1239c3470702568e7b	45	15	Curve.fi Factory Plain Pool: Euro Pool
0x59828fdf7ee634aaad3f58b19fdba3b03e2d9d80	127	15	Euler Proxy
0x378ba9b73309be80bf4c2c027aad799766a7ed5a	27	15	Votium: Multi Merkle Stash
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	82	15	Aave: Lending Pool V2
0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	20	15	Curve.fi: DAI/USDC/USDT Pool
0x29f3dd38db24d3935cf1bf841e6b2b461a3e5d92	23	14	Stake DAO: Angle fee distributor
0x08780fb7e580e492c1935bee4fa5920b94aa95da	33	14	nan
0x5a93d504604fb57e15b0d73733ddc86301dde2f1	37	14	Angle Proxy
0x4a9b7edd67f58654a2c33b587f98c5709ac7d482	27	14	nan

All time User interaction

Most swapped assets all time by token holders

Notable tokens held by agEUR holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']

unique_account_count	name	symbol	price	usd_exposure	address
317	agEUR	agEUR	0.984408	66488871.076645	0x1a7e4e63778b4f12a199c062f3efdd288afcbce8
200	ANGLE	ANGLE	0.025885	1142765.697903	0x31429d1856ad1377a8a0079410b297e1a9e214c2
190	Curve DAO Token	CRV	0.893621	4597178.267203	0xd533a949740bb3306d119cc777fa900ba034cd52
187	Frax	FRAX	0.999393	164182124.280443	0x853d955acef822db058eb8505911ed77f175b99e
159	Convex Token	CVX	5.036283	14601848.360072	0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b
113	Frax Share	FXS	6.336399	30163655.473386	0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0
105	Fei USD	FEI	1.000000	54924257.323469	0x956f47f50a910163d8bf957cf5846d573e7f87ca
103	Stake DAO Token	SDT	0.404658	530117.276313	0x73968b9a57c6e53d41345fd57a6e6ae27d6cdb2f
85	Spell Token	SPELL	0.000836	5064296.364036	0x090185f2135308bad17527004364ebcc2d37e5f6
84	Olympus	OHM	54.236073	4004955.409689	0x383518188c0c6d7730d91b2c03a03c837814a899
83	Aave Token	AAVE	83.086360	949376.900838	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9
79	Synthetix Network Token	SNX	2.190435	979944.002626	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f
72	1INCH Token	1INCH	0.560472	396758.754112	0x111111111117dc0aa78b770fa6a738034120c302
72	Compound	COMP	49.589275	306921.160129	0xc00e94cb662c3520282e6f5717214004a7f26888
69	Badger	BADGER	3.170393	425144.966957	0x3472a5a71965499acd81997a54bba8d852c6e53d
65	LUSD Stablecoin	LUSD	1.028224	12416525.613285	0x5f98805a4e8be255a32880fdec7f6728c6568ba0
63	LooksRare Token	LOOKS	0.218606	1294962.132990	0xf4d2888d29d722226fafa5d9b24f9164c092421e
63	STASIS EURS Token	EURS	1.022560	19984773.276594	0xdb25f211ab05b1c97d595516f45794528a807ad8
63	Alchemix	ALCX	19.334600	1013323.980545	0xdbdb4d16eda451d0503b854cf79d55697f90c8df
63	Convex CRV	cvxCRV	0.832375	928009.793653	0x62b9c7356a2dc64a1969e19c23e4f579f9810aa7

• This Could be improved by labeling tokens category such as (DeFi, P2E, Stables etc ...)
• Same table can be done with all accounts that interacted with the token, not only the current holders

Most used contracts by holders by removing ERC20 Tokens

to_address	transaction_count	unique_account_count	label
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45	4778	281	Uniswap V3 Router
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	10945	277	SushiSwap Router
0xe592427a0aece92de3edee1f18e0157c05861564	4463	239	Uniswap V3 Router
0x1111111254fb6c44bac0bed2854e76f90643097d	25680	220	1inch v4 Router
0xa0c68c638235ee32657e8f720a23cec1bfc77c77	2938	208	Polygon Matic Bridge
0xf403c135812408bfbe8713b5a23a04b3d48aae31	1637	196	Convex Finance: Booster
0x5addc89785d75c86ab939e9e15bfbbb7fc086a87	572	181	nan
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f	444	173	Arbitrum: Delayed Inbox
0xdef1c0ded9bec7f1a1670819833240f027b25eff	7483	169	0x: Exchange Proxy
0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	855	159	Curve.fi: DAI/USDC/USDT Pool
0xa79828df1850e8a3a3064576f380d90aecdd3359	1165	153	Curve Finance: 3Pool Deposit Zap
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	2796	150	Paraswap Augustus v5
0x11111112542d85b3ef69ae05771c2dccff4faa26	5836	141	1inch v3
0xba12222222228d8ba445958a75a0704d566bf2c8	1503	140	Balancer Vault
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	3051	133	Aave: Lending Pool V2
0xa5409ec958c83c3f309868babaca7c86dcb077c1	134	127	Opensea Registry
0x881d40237659c251811cec9c364ef91dc08d300c	900	126	Metamask Router
0x7be8076f4ea4a4ad08075c2508e481d6c946d12b	3522	126	Opensea Wyvern exchange V1
0xb9446c4ef5ebe66268da6700d26f96273de3d571	551	121	Curve.fi Factory Plain Pool: 3EURpool
0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	271	118	Optimism Gateway
0xd061d61a4d941c39e5453435b6345dc261c2fce0	1361	113	nan
0x469788fe6e9e9681c6ebf3bf78e7fd26fc015446	283	108	Snapshot: Delegation
0x4678f0a6958e4d2bc4f1baf7bc52e8f3564f3fe4	109	106	Maker: Proxy Registry
0xd632f22692fac7611d2aa1c0d552930d43caed3b	409	101	nan
0xdd49a93fdcae579ae50b4b9923325e9e335ec82b	560	100	Convex: Claim Zap
0x283af0b28c62c092c9727f1ee09c02ca627eb7f5	710	100	ENS: ETH Registrar Controller
0x92cf9e5e4d1dfbf7da0d2bb3e884a68416a65070	422	96	nan
0xabea9132b05a70803a4e85094fd0e1800777fbef	170	94	zkSync

Open questions and ideas

New Holders/Users analysis and notifications

Should we show holdings evolution through time ? Or interactions through time ? Daily contract Usage

Stickyness and churn analysis ? Analyse how many addresses keep using the contract or churned ?

Add a User leader board ?

Should we perform the same analysis on only active addresses ? Or historical users ?

Should we try deducting timezones based on activity timestamp ?

For general contracts should we add a google analytics Integration ?

What other labels can we add ?

Should we tag tokens and contracts in different categories such as DEFI, P2E ... ?

What other data do you want to measure on your users/holders ?

Are True User balance in ERC20 and ERC721 Usefull ?

Should We add a community tool ? Could be used to find Addresses that belong to the same owner or that have same onchain behaviour ?

Registered ENS analysis, Scrap data about all addresses that have a registered ENS.